2014-06-06 - 13189 - Spec - 200399 & 202663 vendor info for SNC #CrystalReportsSupport

SPECIFICATION

13189 - 200399 & 202663 vendor info for SNC

Requirement Summary

---

Create an Ad hoc report for 200399 & 202663 vendor info(Input has to be retrieved from an excel sheet).

Admin Info

---

Purpose	200399 & 202663 vendor info for SNC.
Requested By	Saravanan Lakshmanan
Spec Created By	Praveen Guntuka
Spec Created Date	06-09-2014
Spec QA by	Uday Kumar P
Objects	Ad hoc report
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

1. Need to create an ad hoc report for 200399 & 202663 vendor information for SNC.
2. Need to retrieve Season information from Seasons Sheet.

Solution Summary

---

1. Need to restrict the Vendors for 200399 & 202663 in report level.
2. Need to add sheet in the Database Expert in Crystal report designer.
3. Need to link the sheet and the table.

Solution Details

---

1. Need to restrict the Vendors for 200399 & 202663 in record selection at report level.
2. Need to add apostrophe in front of the numbers in the sheet so that it is treated as alphanumeric text in Crystal designer.
3. Need to add the sheet in database expert.
4. Need to link the Seasons from Sheet to Season from ECC table 'J_3ASEAN'.

Issues

---

None